Back

C.R.U.D app

About

Objective:
The aim of the C.R.U.D 1.0 project is to provide a simple yet functional application for performing basic C.R.U.D (Create, Read, Update, Delete) operations on a CRM database. The application allows users to interact with a SQL Server database, perform data entry, update existing records, delete records, and execute custom SQL queries.

Key Features:

  • ➡️ User-Friendly Interface:

    • The graphical user interface (GUI) is designed to be intuitive and user-friendly.
    • Implemented using the Tkinter library in Python.
  • ➡️ C.R.U.D Operations:

    • Create: Users can add new customer records to the database.
    • Read: The application displays the latest customer records in a table format.
    • Update: Users can modify existing customer records.
    • Delete: Users can remove customer records from the database.
  • ➡️ SQL Query Execution:

    • Users have the ability to execute custom SQL queries.
    • The results of the queries are displayed in a table, enhancing user interaction with the database.
  • ➡️ Preview Functionality:

    • Users can preview the first 50 records in the database to get a quick overview.
  • ➡️ Error Handling:

    • The application includes comprehensive error handling to guide users and prevent unintended actions.

For the full documentation, Please visit my GitHub account: GitHub

Back